Efficient Locking and Caching of Data in the Multisystem Shard Disks Transaction Environment
نویسندگان
چکیده
This paper describes a technique for use when multiple instances of a data base management system (DBMS), each with its own cache (buffer pool), can directly read and modify any data stored on a set of shared disks. Global locking and coherency control protocols are necessary in this context for assuring transaction consistency and for maintaining coherency of the data cached in the multiple caches. The coordination amongst the systems is performed by a set of local lock managers (LLMs) and a global lock manager (GLM). This typically involves sending messages. We describe a technique, called LP locking, which saves locking calls when the granularity of locking by transactions is the sase as the granularity of caching by the cache manager. The savings are gained by making the LLMs hide from the GLM the distinction between a transaction lock, called the L lock, and a cache-ownership lock, called the P lock, for the same object. The L and P locks for an object, though distinct at an LLM, are known as a single lock at the GLM. An LLM can grant an L or P lock request on an object locally if the combined lock mode of the L and P locks already held on that object by that LLM is equal to or higher than the requested mode. Such optimitations save messages between the LLMs and the GLM. Our ideas apply also to the client-server environment which has become very popular in the OODBMS area and to the distributed shared memory environment.
منابع مشابه
Recovery and Coherency-Control Protocols for Fast Intersystem Page Transfer and Fine-Granularity Locking in a Shared Disks Transaction Environment
llbstract This paper proposes schemes for fast page transfer between transaction system Instances In a shared disks (SD) environment where all the sharing Instances can read and modify the same data Fast page transfer improves transaction response time and concurrency because one or more disk I/OS are avoided while transferring a page from a system which modified it to another system which need...
متن کاملon Knowledge and Data Engineering,
C. Mohan and I. Narang. Recovery and coherency-control protocols for fast inter-system page transfer and ne-granularity locking in a shared disks transaction environment .
متن کاملCache Coherency Schemes for Fine-Grained Sharing in a Shared Disks Transaction Environment
Shared disks environment (SDE) refers to a distributed architecture for high performance transaction processing. In SDE, the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To avoid frequent disk accesses, each node caches database pages in its main memory buuer. However, since a particular page may be simultaneously cached in diierent...
متن کاملPerformance of Cache Coherency Schemes in a Shared Disks Transaction Environment
In a shared disks environment (SDE), the computing nodes are locally coupled via a high-speed network and share a common database at the disk level. To reduce the amount of expensive and slow disk I/O, each node caches database pages in its main memory buffer. This paper focuses on SDE that uses recordlevel locking as a concurrency control. While the record-level locking can guarantee higher co...
متن کاملPerformance Evaluation of the Group Two - Phase Locking
In this paper, we discuss the initial results of a detailed simulation of the group two-phase locking (g-2PL) protocol which was developed for gigabit-networked databases. These results show that the grouping of lock grants, client-end caching and data migration proposed in the g-2PL protocol improves the transaction response time upto 25% at moderate to high network latencies, when compared to...
متن کامل